CREATE TABLE [dbo].[TMMODU_SIST]
(
[CO_SIST] [dbo].[TD_VC_008] NOT NULL,
[CO_MODU] [dbo].[TD_VC_008] NOT NULL,
[NO_MODU] [dbo].[TD_VC_050] NOT NULL CONSTRAINT [DF__TMMODU_SI__NO_MO__151B244E] DEFAULT (' '),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TMMODU_SI__CO_US__160F4887] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TMMODU_SI__FE_US__17036CC0] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TMMODU_SI__CO_US__17F790F9] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TMMODU_SI__FE_US__18EBB532] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMMODU_SIST] ADD CONSTRAINT [PK__TMMODU_S__3555AB42116A8EFB] PRIMARY KEY CLUSTERED  ([CO_SIST], [CO_MODU]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMMODU_SIST] ADD CONSTRAINT [FK__TMMODU_SI__CO_SI__3EFC4F81] FOREIGN KEY ([CO_SIST]) REFERENCES [dbo].[TMSIST] ([CO_SIST])
GO
GRANT SELECT ON  [dbo].[TMMODU_SIST] TO [public]
GRANT INSERT ON  [dbo].[TMMODU_SIST] TO [public]
GRANT DELETE ON  [dbo].[TMMODU_SIST] TO [public]
GRANT UPDATE ON  [dbo].[TMMODU_SIST] TO [public]
GO
